<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>live</title>
    <style>
        .index {
            font-weight: bold;
            font-size: 25px;
        }
        .title {
            font-weight: bold;
            font-size: 25px;
        }
        li {
            list-style: none;
            padding: 5px;
        }
        .first-li {
            font-weight: bold;
            font-size: 20px;
        }
        .second-li {
            font-weight: bold;
        }
        .third-li {
            font-weight: normal;
        }
        .block {
            display: block;
        }
        table {
            width: 100%;
            margin-top: 10px;
            border-color: #E8E8E8;
        }
        .first-tr {
            text-align: center;
        }
        tr:hover {
            background: #ECF9FF;
        }
        td {
            font-weight: normal;
            padding: 5px;
            white-space: nowrap;
        }
        a {
            color: #000000;
            background-color: transparent;
            text-decoration: none;
            outline: none;
            cursor: pointer;
        }
        .module {
            color: green;
        }
        .module-list {
            color: #1890ff;
        }
    </style>
</head>
<body><center class="index">目录</center>
<hr><ul>
<li class="first-li"><a class="module" id="module-live-from" href="#module-live-to">1 直播模块</a>
<ul><li class="second-li"><a class="module-list" id="module-live-relation-from" href="#module-live-relation-to">1 关联关系</a></li>
<li class="second-li"><a class="module-list" id="module-live-tableList-from" href="#module-live-tableList-to">2 表清单</a></li>
<li class="second-li"><a class="module-list" id="module-live-tableColumnList-from" href="#module-live-tableColumnList-to">3 表列清单</a>
<ul><li class="third-li"><a id="module-live-tableColumnList-ADMINS-from" href="#module-live-tableColumnList-ADMINS-to">3.1 ADMINS【管理员表】</a></li>
<li class="third-li"><a id="module-live-tableColumnList-LIVES-from" href="#module-live-tableColumnList-LIVES-to">3.2 LIVES【直播表】</a></li>
<li class="third-li"><a id="module-live-tableColumnList-GIFTS-from" href="#module-live-tableColumnList-GIFTS-to">3.3 GIFTS【礼物表】</a></li>
<li class="third-li"><a id="module-live-tableColumnList-CATEGORIES-from" href="#module-live-tableColumnList-CATEGORIES-to">3.4 CATEGORIES【分类表】</a></li>
<li class="third-li"><a id="module-live-tableColumnList-ORDERS-from" href="#module-live-tableColumnList-ORDERS-to">3.5 ORDERS【充值订单表】</a></li>
<li class="third-li"><a id="module-live-tableColumnList-ROOMS-from" href="#module-live-tableColumnList-ROOMS-to">3.6 ROOMS【直播间表】</a></li>
<li class="third-li"><a id="module-live-tableColumnList-USERS-from" href="#module-live-tableColumnList-USERS-to">3.7 USERS【用户表】</a></li>
<li class="third-li"><a id="module-live-tableColumnList-USER_GIFTS-from" href="#module-live-tableColumnList-USER_GIFTS-to">3.8 USER_GIFTS【用户礼物表】</a></li>
</ul></li></ul></li></ul>
<hr><ul>

<li class="first-li"><a class="module" id="module-live-to" href="#module-live-from">1 直播模块</a><ul>
<li class="second-li"><a class="module-list" class="block" id="module-live-relation-to" href="#module-live-relation-from">1.1 关联关系</a>
<img style="width: 98%;margin-top: 10px" src="live.jpg" title="live-关系图"/>
</li><hr>
<li><a class="module-list" id="module-live-tableList-to" href="module-live-tableList-from">1.2  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>管理员表</td><td>ADMINS</td><td></td></tr>
<tr><td>直播表</td><td>LIVES</td><td></td></tr>
<tr><td>礼物表</td><td>GIFTS</td><td></td></tr>
<tr><td>分类表</td><td>CATEGORIES</td><td></td></tr>
<tr><td>充值订单表</td><td>ORDERS</td><td></td></tr>
<tr><td>直播间表</td><td>ROOMS</td><td></td></tr>
<tr><td>用户表</td><td>USERS</td><td></td></tr>
<tr><td>用户礼物表</td><td>USER_GIFTS</td><td></td></tr>
</table>
</li><hr>

<li><a class="module-list" id="module-live-tableColumnList-to" href="module-live-tableColumnList-from">1.3 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="module-live-tableColumnList-ADMINS-to" href="module-live-tableColumnList-ADMINS-from">1.3.1 ADMINS【管理员表】</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>编号</td><td>INT UNSIGNED(10)</td><td>√</td><td></td></tr>
<tr><td>ACCOUNT</td><td>账号</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>PASSWORD</td><td>密码</td><td>VARCHAR(32)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-live-tableColumnList-LIVES-to" href="module-live-tableColumnList-LIVES-from">1.3.2 LIVES【直播表】</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>编号</td><td>INT UNSIGNED(10)</td><td>√</td><td></td></tr>
<tr><td>USER_ID</td><td>主播ID</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
<tr><td>ADDTIME</td><td>创建时间戳</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
<tr><td>PUSH_URL</td><td>推流地址</td><td>VARCHAR(255)</td><td></td><td></td></tr>
<tr><td>PULL_URL</td><td>拉流地址</td><td>VARCHAR(255)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-live-tableColumnList-GIFTS-to" href="module-live-tableColumnList-GIFTS-from">1.3.3 GIFTS【礼物表】</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>编号</td><td>INT UNSIGNED(10)</td><td>√</td><td></td></tr>
<tr><td>GIFT_NAME</td><td>礼物名称</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>GIFT_ICON</td><td>礼物图标</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>PRICE</td><td>礼物价格</td><td>DECIMAL UNSIGNED(10,2)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-live-tableColumnList-CATEGORIES-to" href="module-live-tableColumnList-CATEGORIES-from">1.3.4 CATEGORIES【分类表】</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>编号</td><td>INT UNSIGNED(10)</td><td>√</td><td></td></tr>
<tr><td>CAT_NAME</td><td>分类名称</td><td>VARCHAR(32)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-live-tableColumnList-ORDERS-to" href="module-live-tableColumnList-ORDERS-from">1.3.5 ORDERS【充值订单表】</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>编号</td><td>INT UNSIGNED(10)</td><td>√</td><td></td></tr>
<tr><td>ADDTIME</td><td>充值时间</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
<tr><td>USER_ID</td><td>用户ID</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
<tr><td>MONEY</td><td>充值金额</td><td>DECIMAL UNSIGNED(10,2)</td><td></td><td></td></tr>
<tr><td>ORDER_SN</td><td>订单编号</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>PAY_STATUS</td><td>支付状态 0：未支付  1：已支付</td><td>TINYINT UNSIGNED(1)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-live-tableColumnList-ROOMS-to" href="module-live-tableColumnList-ROOMS-from">1.3.6 ROOMS【直播间表】</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>编号</td><td>INT UNSIGNED(10)</td><td>√</td><td></td></tr>
<tr><td>ROOM_NAME</td><td>直播间名称</td><td>VARCHAR(32)</td><td></td><td></td></tr>
<tr><td>ROOM_INTRODUCE</td><td>直播间描述</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>USER_ID</td><td>主播ID</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
<tr><td>ADDTIME</td><td>创建时间</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
<tr><td>USER_COUNT</td><td>房间人数</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
<tr><td>LOGO</td><td>封面图片</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>PLAY_URL</td><td>播放地址</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>CATEGORY_ID</td><td>分类ID</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-live-tableColumnList-USERS-to" href="module-live-tableColumnList-USERS-from">1.3.7 USERS【用户表】</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>编号</td><td>INT UNSIGNED(10)</td><td>√</td><td></td></tr>
<tr><td>MOBILE</td><td>手机号码</td><td>CHAR(11)</td><td></td><td></td></tr>
<tr><td>AVATAR</td><td>头像</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>NAME</td><td>昵称</td><td>VARCHAR(128)</td><td></td><td></td></tr>
<tr><td>MONEY</td><td>余额</td><td>DECIMAL UNSIGNED(10,2)</td><td></td><td></td></tr>
<tr><td>PASSWORD</td><td>密码</td><td>CHAR(32)</td><td></td><td></td></tr>
<tr><td>ROOM_ID</td><td>房间ID</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="module-live-tableColumnList-USER_GIFTS-to" href="module-live-tableColumnList-USER_GIFTS-from">1.3.8 USER_GIFTS【用户礼物表】</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>主键</td><td>备注</td></tr>
<tr><td>ID</td><td>编号</td><td>INT UNSIGNED(10)</td><td>√</td><td></td></tr>
<tr><td>ADDTIME</td><td>送礼时间戳</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
<tr><td>FROM_ID</td><td>送礼人</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
<tr><td>TO_ID</td><td>收礼人</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
<tr><td>GIFT_ID</td><td>礼物ID</td><td>INT UNSIGNED(10)</td><td></td><td></td></tr>
<tr><td>PRICE</td><td>礼物价格</td><td>DECIMAL UNSIGNED(10,2)</td><td></td><td></td></tr>
</table>
</li>

</ul></li></ul><hr></li></ul></body>
</html>